package com.yycwxt.modules.admin.xstj;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.time.LocalDateTime;

@Mapper
public interface XstjMapper {

    //上传
    @Select("call importXstj(#{zq,mode=IN,jdbcType=INTEGER},#{dp,mode=IN,jdbcType=VARCHAR}," +
            "#{xse,mode=IN,jdbcType=DECIMAL},#{tke,mode=IN,jdbcType=DECIMAL},#{sdje,mode=IN,jdbcType=DECIMAL}," +
            "#{sc,mode=IN,jdbcType=DECIMAL},#{sjxsje,mode=IN,jdbcType=DECIMAL},#{xsdd,mode=IN,jdbcType=INTEGER},#{sddd,mode=IN,jdbcType=INTEGER}" +
            ",#{dds,mode=IN,jdbcType=INTEGER},#{sdyj,mode=IN,jdbcType=DECIMAL},#{ztc,mode=IN,jdbcType=DECIMAL},#{cjtj,mode=IN,jdbcType=DECIMAL}" +
            ",#{zszw,mode=IN,jdbcType=DECIMAL},#{tbk,mode=IN,jdbcType=DECIMAL},#{jd,mode=IN,jdbcType=DECIMAL},#{pdd,mode=IN,jdbcType=DECIMAL});")
    public void importKdfdzd(Integer zq, String dp, BigDecimal xse, BigDecimal tke, BigDecimal sdje,
                            BigDecimal sc, BigDecimal sjxsje, Integer xsdd, Integer sddd,
                             Integer dds, BigDecimal sdyj, BigDecimal ztc, BigDecimal cjtj,
                             BigDecimal zszw, BigDecimal tbk, BigDecimal jd, BigDecimal pdd);

}
